ActiveReports 9
Recursive Hierarchy Reports
Show AllShow All
Hide AllHide All

You can create a report using a recursive hierarchy and the Level function to show parent-child relationships in data. This walkthrough illustrates how to create a recursive hierarchy report.

The walkthrough is split into the following activities:

Note:
  • This walkthrough uses the Store table from the Reels database. By default, in ActiveReports, the Reels.mdb file is located in the [User Documents folder]\GrapeCity Samples\ActiveReports 9\Samples\Data folder.
  • Although this walkthrough uses Page reports, but this can be implemented using RDL reports also.

When you complete this walkthrough you get a layout that looks similar to the following at design time and at runtime.

Design Time Layout

Runtime Layout

To add an ActiveReport to the Visual Studio project

To connect the report to a data source

To create a dataset to populate the parameter values

To add a report parameter

To add a dataset for the report

To create a layout for the report

To set up a recursive hierarchy

To use the Level function to display the hierarchy

To use the Level function with themes in the BackgroundColor property of a textbox

To view the report

See Also

Concepts

 

 


Copyright © 2016 GrapeCity, inc. All rights reserved

Support Forum